﻿
CREATE PROCEDURE [svc].[GetSessionLogAverageAndMaxReadTime]
(
	@FromDate				datetime,
	@ToDate					datetime 
)
AS
BEGIN


SELECT MAX(Reads) AS MaxReadTime, AVG(Reads) *100 / MAX(Reads) AS AverageReadTime 
FROM dbo.ExecSessionLog 
WHERE LastModifiedDate BETWEEN @FromDate AND @ToDate 

END